{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Inicio","Capacidad y Actividad","Costes Estimados","Rtdo Analitico y KPI","Estandar Simulador","Notas","KPIs","Hipervinculos"],"not_rendered":{"charts":0,"images":27,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inicio","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,1,8,8],[9,1,9,8],[30,1,30,4],[31,1,31,4]]}
[]
[]
[]
[]
[]
[]
[null,"\"… la hoja de cálculo es un instrumento extraordinariamente potente, de fácil uso y versátil pero puede contener graves errores ocultos derivados de fallos cometidos en el diseño del modelo “"]
[]
[]
[null,"……. Consejo: Audite continuamente sus diseños…"]
[]
[]
["Indice General"]
[]
[null,"Consideraciones técnicas y de actividad"]
[null,null,"Capacidad de producción. Óptima - Normal - Prevista"]
[null,null,"Estimación de activdad - Ratios de actividad."]
[null,null,"Estimación de ingresos"]
[null,null,null,"Ingresos anuales previstos"]
[null,null,null,"Ingreso medios por carrera"]
[null,null,"Insumos básicos (conusmo medio y precio combustible)"]
[null,null,"Otros costes no gastos (financieros y oportunidad)"]
[]
[null,"Costes estimados - Actividad Normal"]
[]
[null,"Resultado Analítico y KPI`s"]
[null,null,"Resultado Analítico. Normal y Previsto"]
[null,null,"KPI. Normal y Simulador"]
[]
[null,"Consejos de navegacion a tráves de los vínculos del libro"]
[null,"Volver al vínculo anterior",null,null,null,"ALT + ←","ALT+FLECHA IZQUIERDA"]
[null,"Volver al vínculo siguiente",null,null,null,"ALT + →","ALT+FLECHA DERECHA"]

{"sheet":"Capacidad y Actividad","index":1,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,1,37,2],[38,1,38,2],[1,1,1,2],[26,1,26,2],[36,1,36,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[20,1,20,2],[2,1,2,2],[27,1,27,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[28,1,28,2],[0,1,0,5],[22,1,22,2],[17,1,17,2],[18,1,18,2],[6,1,7,2],[8,1,8,2],[10,1,11,2],[12,1,12,2],[21,1,21,2],[14,1,14,2],[13,1,13,2],[15,1,15,2],[19,1,19,2]]}
[null,"Consideraciones técnicas y de actividad"]
[{"$f":"HYPERLINK(Hipervinculos!C7,Hipervinculos!D7)","v":"N1"},"Capacidad de Producción",null,"Óptima","Normal","Prevista"]
[null,"Nº de taxis",null,1,1,1]
[null,"Dias operativos Año",null,365,325,280]
[null,"Nº de conductores ",null,2,2,2]
[null,"Horas totales año",null,{"$f":"D5*8*D4*D3","v":5840},{"$f":"E5*8*E4*E3","v":5200},{"$f":"F5*8*F4*F3","v":4480}]
[null,"Horas ajustadas año",null,0.2,0.3,0.35]
[null,null,null,{"$f":"D6-(D6*D7)","v":4672},{"$f":"E6-(E6*E7)","v":3640},{"$f":"F6-(F6*F7)","v":2912}]
[{"$f":"HYPERLINK(Hipervinculos!C4,Hipervinculos!D4)","v":"N2"},"Estimación de Actividad",null,{"$f":"D2","v":"Óptima"},{"$f":"E2","v":"Normal"},{"$f":"F2","v":"Prevista"}]
[null,"Total horas de servicio disponible",null,{"$f":"D8","v":4672},{"$f":"E8","v":3640},{"$f":"F8","v":2912}]
[null,"Tasa de horas de espera (parada)",null,0.08,0.1,7.0000000000000007E-2]
[null,null,null,{"$f":"D11*D10","v":373.76},{"$f":"E11*E10","v":364},{"$f":"F11*F10","v":203.84000000000003}]
[null,"Horas en marcha",null,{"$f":"D10-D12","v":4298.24},{"$f":"E10-E12","v":3276},{"$f":"F10-F12","v":2708.16}]
[null,"Km recorridos al año",null,120000,100000,95000]
[null,"% tiempo de ocupación",null,0.9,0.75,0.7]
[null,"Bajadas de bandera año",null,25000,30000,27000]
[null,"Ratios de actividad"]
[null,"Km recorridos al año ocupado",null,{"$f":"D15*D14","v":108000},{"$f":"E15*E14","v":75000},{"$f":"F15*F14","v":66500}]
[null,"Km recorridos al año desocupado",null,{"$f":"D14-D18","v":12000},{"$f":"E14-E18","v":25000},{"$f":"F14-F18","v":28500}]
[null,"Duración media de la carrera",null,{"$f":"(D13*D15)/D16","v":0.15473663999999998},{"$f":"(E13*E15)/E16","v":8.1900000000000001E-2},{"$f":"(F13*F15)/F16","v":7.0211555555555541E-2}]
[null,"Km promedio por carrera",null,{"$f":"(D14*D15)/D16","v":4.32},{"$f":"(E14*E15)/E16","v":2.5},{"$f":"(F14*F15)/F16","v":2.4629629629629628}]
[null,"Promedio carrera dia",null,{"$f":"D16/D4","v":68.493150684931507},{"$f":"E16/E4","v":92.307692307692307},{"$f":"F16/F4","v":96.428571428571431}]
[{"$f":"HYPERLINK(Hipervinculos!C11,Hipervinculos!D11)","v":"N3"},"Estimación de Ingresos",null,{"$f":"D9","v":"Óptima"},{"$f":"E9","v":"Normal"},{"$f":"F9","v":"Prevista"}]
[null,"Tarifa promedio bajada bandera"]
[null,"Incluye",1.5,{"$f":"$C$25*D16","v":37500},{"$f":"$C$25*E16","v":45000},{"$f":"$C$25*F16","v":40500}]
[null,"Tasa",3.15,{"$f":"$C$26*D16","v":78750},{"$f":"$C$26*E16","v":94500},{"$f":"$C$26*F16","v":85050}]
[null,"Tarifa promedio por km ocupado",null,1.25,1.1499999999999999,1.1499999999999999]
[null,"Suplemento medio por carrera",null,0.25,0.2,0.2]
[null,"Ingresos anuales previstos:",null,{"$f":"(D27*(D18-D25))+(D28*D16)+D26","v":173125},{"$f":"(E27*(E18-E25))+(E28*E16)+E26","v":135000},{"$f":"(F27*(F18-F25))+(F28*F16)+F26","v":120350}]
[null,"Otros Ingresos Publicidad y Patrocinio",null,{"$f":"1500","v":1500},800,600]
[null,"Ingreso medio por km recorr. ocupado",null,{"$f":"(D29+D30)/D18","v":1.6168981481481481},{"$f":"(E29+E30)/E18","v":1.8106666666666666},1.8187969924812031]
[null,"Ingreso medio por km recorrido total",null,{"$f":"(D29+D30)/D14","v":1.4552083333333334},{"$f":"(E29+E30)/E14","v":1.3580000000000001},1.273157894736842]
[null,"Ingreso medio por carrera",null,{"$f":"(D29+D30)/D16","v":6.9850000000000003},{"$f":"(E29+E30)/E16","v":4.5266666666666664},{"$f":"(F29+F30)/F16","v":4.4796296296296294}]
[{"$f":"HYPERLINK(Hipervinculos!C8,Hipervinculos!D8)","v":"N4"},"Insumos Básicos",null,{"$f":"D23","v":"Óptima"},{"$f":"E23","v":"Normal"},{"$f":"F23","v":"Prevista"}]
[null,"Coste promedio del combustible",null,0.95399999999999996,0.91900000000000004,0.91900000000000004]
[null,"Consumo promedio combustible",null,6,6.2,6.1]
[{"$f":"HYPERLINK(Hipervinculos!C12,Hipervinculos!D12)","v":"N5"},"Otros Costes No Gastos",null,{"$f":"D34","v":"Óptima"},{"$f":"E34","v":"Normal"},{"$f":"F34","v":"Prevista"}]
[null,"Cosets financieros del periodo",null,1400,1200,1000]
[null,"Coste de oportunidad",null,10000,3000,4000]

{"sheet":"Costes Estimados","index":2,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,1,35,2],[0,1,0,6],[1,5,1,6],[2,5,2,6],[15,1,15,2],[3,6,4,6],[5,1,5,2],[6,1,6,2],[10,1,10,2],[8,1,8,2],[9,1,9,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[1,3,1,4],[18,1,18,2],[16,1,16,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[17,1,17,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[34,1,34,2],[32,1,32,2],[27,1,27,2],[30,1,30,2],[31,1,31,2],[29,1,29,2],[28,1,28,2]]}
[null,"Costes Estimados - Actividad Normal -"]
[null,null,null,"Actividad Normal",null,{"$f":"'Capacidad y Actividad'!E14","v":100000}]
[null,null,null,null,null,"Cerntros de Costes"]
[null,null,null,null,null,"Taxi","Estructura Costes Fijos"]
[null,null,null,"Valor","%","C. Variable"]
[null,"(60-61) Consumos",null,{"$f":"F6+G6","v":5829},{"$f":"D6/$D$33","v":7.9581137536520768E-2},{"$f":"SUM(F7:F11)","v":5724},{"$f":"SUM(G7:G11)","v":105}]
[null,"(602.1) Combustible",null,{"$f":"('Capacidad y Actividad'!D36*'Costes Estimados'!F2)/100","v":6000}]
[null,null,null,{"$f":"D7*'Capacidad y Actividad'!D35","v":5724},null,{"$f":"D8","v":5724}]
[null,"(602.2) Papelería",null,25,null,null,{"$f":"D9","v":25}]
[null,"(602.3) Limpieza",null,50,null,null,50]
[null,"(602.4) Otros complementos",null,30,null,null,{"$f":"D11","v":30}]
[null,"(62) Servicios Exteriores",null,{"$f":"F12+G12","v":4277},{"$f":"D12/$D$33","v":5.839226715452038E-2},{"$f":"SUM(F13:F19)","v":875},{"$f":"SUM(G13:G19)","v":3402}]
[null,"(621) Arrendam. y Canónes",null,{"$f":"60*12","v":720},null,null,{"$f":"D13","v":720}]
[null,"(622.1) Servic. Mecácnica Rápida",null,{"$f":"G14+F14","v":525},null,{"$f":"Notas!G15","v":445},{"$f":"Notas!H15","v":80}]
[null,"(622.2) Servic. Electricidad",null,{"$f":"F15+G15","v":430},null,{"$f":"Notas!G24","v":430}]
[null,"(623.1) Asesoría fiscal y laboral",null,720,null,null,{"$f":"D16","v":720}]
[null,"(623.1) Servicio de limpieza",null,192,null,null,192]
[null,"(625) Seguros vehículo",null,860,null,null,860]
[null,"(629) Otras comunicaciones",null,{"$f":"830","v":830},null,null,{"$f":"D19","v":830}]
[null,"(63) Impuestos",null,{"$f":"F20+G20","v":341},{"$f":"D20/$D$33","v":4.6555443300658056E-3},{"$f":"SUM(F21:F22)","v":0},{"$f":"SUM(G21:G22)","v":341}]
[null,"ITV Taxi y taximetro",null,261,null,null,{"$f":"D21","v":261}]
[null,"Impuestos municipales y otros",null,80,null,null,{"$f":"D22","v":80}]
[null,"64 Personal",null,{"$f":"F23+G23","v":59500},{"$f":"D23/$D$33","v":0.81233104879447338},{"$f":"SUM(F24:F27)","v":0},{"$f":"SUM(G24:G27)","v":59500}]
[null,"(640) Sueldos y salarios",null,{"$f":"Notas!P4","v":42000},null,null,{"$f":"D24","v":42000}]
[null,"(641) Indemnizaciones",null,{"$f":"Notas!P5","v":2500},null,null,{"$f":"D25","v":2500}]
[null,"(642) Seguridad Social Empresa",null,{"$f":"Notas!P6","v":12600},null,null,{"$f":"D26","v":12600}]
[null,"(649) Otros gastos sociales",null,{"$f":"Notas!P7","v":2400},null,null,{"$f":"D27","v":2400}]
[null,"68 Amortizaciones",null,{"$f":"F28+G28","v":2869},{"$f":"D28/$D$33","v":3.9169374436829316E-2},{"$f":"F29+F30","v":2505},{"$f":"G29+G30","v":364}]
[null,"Inmovilizado Intangible",null,{"$f":"G29+F29","v":0},null,{"$f":"Notas!O14","v":0},{"$f":"Notas!P14","v":0}]
[null,"Inmovilizado Material",null,{"$f":"G30+F30","v":2869},null,{"$f":"Notas!O17+Notas!O18","v":2505},{"$f":"Notas!P17+Notas!P18","v":364}]
[null,"69 Deterioro y otras dotaciones",null,{"$f":"F31+G31","v":430},{"$f":"D31/$D$33","v":5.8706277475903124E-3},{"$f":"F32","v":80},{"$f":"G32","v":350}]
[null,"(699) Dotación costes plurianuales",null,{"$f":"Notas!P23+Notas!O23","v":430},null,{"$f":"Notas!O23","v":80},{"$f":"Notas!P23","v":350}]
[null,"Total Costes del Periodo",null,{"$f":"D6+D12+D20+D23+D28+D31","v":73246},null,{"$f":"F31+F28+F23+F20+F12+F6","v":9184},{"$f":"G31+G28+G23+G20+G12+G6","v":64062}]
[null,"SI","XX Otros costes",{"$f":"F34+G34","v":18500},{"$f":"D34/$D$33","v":0.25257351937307154},{"$f":"IF(B34=\"SI\",F35,0)","v":0},{"$f":"IF(B34=\"SI\",G35,0)","v":18500}]
[null,"(XXX) Financ., oportunidad y otros",null,{"$f":"G35+F35","v":18500},null,{"$f":"Notas!O31","v":0},{"$f":"Notas!P31","v":18500}]
[null,"Total Costes Ajustado",null,{"$f":"D33+D34","v":91746},null,{"$f":"F33+F34","v":9184},{"$f":"G34+G31+G26+G23+G15+G9","v":90975}]

{"sheet":"Rtdo Analitico y KPI","index":3,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,8,2],[3,5,3,6],[4,3,4,4],[4,5,4,6],[6,3,6,4],[7,3,7,4],[5,3,5,4],[5,5,5,6],[6,5,6,6],[0,12,0,19],[0,2,0,6],[3,3,3,4],[2,5,2,6],[2,1,2,2],[2,3,2,4],[13,3,13,4],[2,11,2,13],[3,7,3,8],[13,1,13,2],[14,1,14,2],[14,3,14,4],[12,5,12,6],[13,5,13,6],[14,5,14,6],[12,3,12,4],[9,2,10,2],[9,3,9,4],[9,5,9,6],[10,3,10,4],[10,5,10,6],[11,1,11,2],[15,1,15,2],[19,3,19,4],[20,3,20,4],[21,1,21,2],[22,3,22,4],[16,1,16,2],[16,3,16,4],[17,3,17,4],[18,3,18,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,1,27,2],[35,3,35,4],[31,1,31,2],[28,3,28,4],[30,3,30,4],[29,3,29,4],[32,1,32,2],[32,3,32,4],[33,3,33,4],[34,3,34,4],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[32,5,32,6],[35,5,35,6],[33,5,33,6],[34,5,34,6]]}
[null,null,"Resultado Analítico",null,null,null,null,null,null,null,null,null,"KPI  Normal vs Simulador"]
[]
[null,"Nivel de Actividad",null,{"$f":"'Capacidad y Actividad'!E2","v":"Normal"},null,{"$f":"'Capacidad y Actividad'!F2","v":"Prevista"}]
[null,null,"Nivel de Actividad ",{"$f":"'Capacidad y Actividad'!E14","v":100000},null,{"$f":"'Estandar Simulador'!E4","v":95000},null,null,null,null,{"$f":"(F4-D4)/D4","v":-0.05}]
[null,null,"Tasa de subactividad 1",{"$f":"(F4/D4)-1","v":-5.0000000000000044E-2},null,{"$f":"F4-D4","v":-5000}]
[null,null,{"$f":"'Capacidad y Actividad'!B16","v":"Bajadas de bandera año"},{"$f":"'Capacidad y Actividad'!E16","v":30000},null,{"$f":"'Estandar Simulador'!E5","v":27000},50,null,null,null,{"$f":"(F6-D6)/D6","v":-0.1}]
[null,null,"Tasa de subactividad 2",{"$f":"(F6/D6)-1","v":-9.9999999999999978E-2},null,{"$f":"F6-D6","v":-3000}]
[]
[null,"Ingresos",null,"Véase:",{"$f":"HYPERLINK(Hipervinculos!C11,Hipervinculos!E11)","v":"Anexo Ingresos (70..)"}]
[null,null,{"$f":"'Capacidad y Actividad'!B32","v":"Ingreso medio por km recorrido total"},{"$f":"'Capacidad y Actividad'!E32","v":1.3580000000000001},null,{"$f":"'Capacidad y Actividad'!F32","v":1.273157894736842}]
[null,null,null,{"$f":"D10*D4","v":135800},null,127950,null,null,null,null,{"$f":"(F11-D11)/D11","v":-5.7805596465390283E-2}]
[null,"Costes Variables"]
[null,null,"Total de Costes Variables",{"$f":"'Costes Estimados'!F33","v":9184},null,{"$f":"'Estandar Simulador'!E8","v":9184},null,null,null,null,{"$f":"(F13-D13)/D13","v":0}]
[null,"por km recorrrido...",null,{"$f":"D13/D4","v":9.1840000000000005E-2},null,{"$f":"F13/F4","v":9.6673684210526314E-2}]
[null,"por bajada de bandera..",null,{"$f":"D13/D6","v":0.30613333333333331},null,{"$f":"F13/F6","v":0.34014814814814814}]
[null,"Márgen de Contribución"]
[null,"Marg. Contrib. Total",null,{"$f":"D11-D13","v":126616},null,{"$f":"F11-F13","v":118766}]
[null,null,{"$f":"B14","v":"por km recorrrido..."},{"$f":"D17/D4","v":1.26616},null,{"$f":"F17/F4","v":1.2501684210526316}]
[null,null,null,{"$f":"D18/D10","v":0.93237113402061844},null,{"$f":"F18/F10","v":0.98194295163290624}]
[null,null,{"$f":"B15","v":"por bajada de bandera.."},{"$f":"D17/D6","v":4.220533333333333},null,{"$f":"F17/F6","v":4.3987407407407408}]
[null,null,null,{"$f":"D20/D10","v":3.1079037800687281},null,{"$f":"F20/F10","v":3.4549844594491144}]
[null,"Costes fijos y subactividad"]
[null,null,"Total Costes Fijos",{"$f":"'Costes Estimados'!G33","v":64062},null,{"$f":"'Estandar Simulador'!E9","v":64062},null,null,null,null,{"$f":"(F23-D23)/D23","v":0}]
[null,null,{"$f":"C5","v":"Tasa de subactividad 1"},{"$f":"(D23*D5)*-1","v":3203.1000000000026},null,{"$f":"(F23*D5)*-1","v":3203.1000000000026}]
[null,null,{"$f":"C7","v":"Tasa de subactividad 2"},{"$f":"(D23*D7)*-1","v":6406.1999999999989},null,{"$f":"(F23*D7)*-1","v":6406.1999999999989}]
[null,null,"Costes fijos imputables 1",{"$f":"D23-D24","v":60858.899999999994},null,{"$f":"F23-F24","v":60858.899999999994}]
[null,null,"Costes fijos imputables 2",{"$f":"D23-D25","v":57655.8},null,{"$f":"F23-F25","v":57655.8}]
[null,"Resultado Analítico Total"]
[null,null,"Resultado Bruto",{"$f":"D17-D23","v":62554},null,{"$f":"F17-F23","v":54704}]
[null,null,"Rtdo. Bruto por Km",{"$f":"(D29)/D4","v":0.62553999999999998},null,{"$f":"(F29)/F4","v":0.57583157894736847}]
[null,null,"Rtdo. Bruto por Carrera",{"$f":"(D29)/D6","v":2.0851333333333333},null,{"$f":"(F29)/F6","v":2.0260740740740739}]
[null,"Resultado Analítico Ajustado"]
[null,{"$f":"'Costes Estimados'!B35","v":"(XXX) Financ., oportunidad y otros"},null,{"$f":"'Costes Estimados'!D35","v":18500},null,{"$f":"'Estandar Simulador'!E10","v":18500},null,null,null,null,{"$f":"(F33-D33)/D33","v":0}]
[null,null,"Resultado Ajustado",{"$f":"D29-D33","v":44054},null,{"$f":"'Estandar Simulador'!E10","v":18500}]
[null,null,"Rtdo. Ajustado por Km",{"$f":"(D29-D33)/D4","v":0.44053999999999999},null,{"$f":"(F29-F33)/F4","v":0.38109473684210526}]
[null,null,"Rtdo. Ajustado por Carrera",{"$f":"(D29-D33)/D6","v":1.4684666666666666},null,{"$f":"(F29-F33)/F6","v":1.3408888888888888}]

{"sheet":"Estandar Simulador","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[[4,2,4,3],[4,4,4,5],[39,2,39,3],[39,4,39,5],[0,1,0,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[3,4,3,5],[40,2,40,3],[5,1,6,1],[5,2,5,3],[5,4,5,5],[6,2,6,3],[6,4,6,5],[37,2,37,3],[37,4,37,5],[9,2,9,3],[9,4,9,5],[8,2,8,3],[8,4,8,5],[7,2,7,3],[7,4,7,5]]}
[null,"Valores estandar"]
[]
[null,null,{"$f":"'Capacidad y Actividad'!E2","v":"Normal"},null,{"$f":"'Capacidad y Actividad'!F2","v":"Prevista"}]
[null,"Nivel de Actividad ",{"$f":"'Capacidad y Actividad'!E14","v":100000},null,{"$f":"'Capacidad y Actividad'!F14","v":95000}]
[null,{"$f":"'Capacidad y Actividad'!B16","v":"Bajadas de bandera año"},{"$f":"'Capacidad y Actividad'!E16","v":30000},null,{"$f":"'Capacidad y Actividad'!F16","v":27000}]
[null,{"$f":"'Capacidad y Actividad'!B32","v":"Ingreso medio por km recorrido total"},{"$f":"'Capacidad y Actividad'!E32","v":1.3580000000000001},null,{"$f":"'Capacidad y Actividad'!F32","v":1.273157894736842}]
[null,null,{"$f":"C6*C4","v":135800},null,{"$f":"E6*E4","v":120950}]
[null,"Total de Costes Variables",{"$f":"'Costes Estimados'!F33","v":9184},null,{"$f":"'Costes Estimados'!F33","v":9184}]
[null,"Total Costes Fijos",{"$f":"'Costes Estimados'!G33","v":64062},null,{"$f":"'Costes Estimados'!G33","v":64062}]
[null,{"$f":"'Costes Estimados'!B35","v":"(XXX) Financ., oportunidad y otros"},{"$f":"'Costes Estimados'!D35","v":18500},null,{"$f":"'Costes Estimados'!D35","v":18500}]

{"sheet":"Notas","index":5,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[54,1,54,2],[2,9,2,11],[33,0,34,5],[0,1,1,6],[27,1,28,4],[1,17,2,24],[3,17,3,18],[4,1,5,6],[1,12,1,13],[16,12,16,13]]}
[null,"Estimacion de costes y clasificación",null,null,null,null,null,null,null,"N_64: Personal",null,null,null,null,"Variable","Fijo",null,"N_70: Ingresos por los servicios"]
[null,null,null,null,null,null,null,null,null,"Para la actividad prevista como normal",null,null,{"$f":"'Costes Estimados'!F2","v":100000},null,{"$f":"'Costes Estimados'!F20","v":0},{"$f":"'Costes Estimados'!G23","v":59500},null,"Las estimaciones están basadas en nuestros datos históricos, así como los diferentes escenarios previstos sobre el nivel de actividad"]
[null,null,null,null,null,null,null,null,null,"Conductores promedio anual:",null,null,{"$f":"'Capacidad y Actividad'!E5","v":2}]
[null,"N_60-61: Consumos Grupo 60 -61 Consumos",null,null,null,null,null,null,null,"640. Sueldos y salarios",null,null,null,{"$f":"1500*14","v":21000},null,{"$f":"N4*M3","v":42000},null,"Véase Anexo:",null,"Acceso Ingresos"]
[null,"El consumo de combustible lo estimamos según la actividad prevista en km y el coste medio del litro de gasolina",null,null,null,null,null,null,null,"641. Indemnizaciones",null,null,null,2500,null,{"$f":"N5","v":2500},null,"También esta relacionada con la estimación de actividad"]
[null,null,null,null,null,null,null,null,null,"642. Seguridad Social Empresa",null,null,0.3,{"$f":"M6*N4","v":6300},null,{"$f":"N6*M3","v":12600}]
[null,"Limpieza incluye los kit básicos de limpieza diaria  a realizar por el conductor",null,null,null,null,null,null,null,"649. Otros gtoss: vestuario, seguridad, etc..",null,null,null,1200,null,{"$f":"N7*M3","v":2400}]
[null,"Otros complementos incluye ambientadores, agua, caramelos y otros suministros"]
[null,null,null,null,null,null,null,null,null,"Véase:",{"$f":"HYPERLINK(Hipervinculos!C13,Hipervinculos!E13)","v":"Anexo Pesonal (64)"}]
[null,"Véase:",{"$f":"HYPERLINK(Hipervinculos!C8,Hipervinculos!E8)","v":"Anexo Consumo (60.61)"},null,"N2: Estimación de actividad"]
[null,null,"N4: Insumos básicos",null,null,null,null,null,null,"N_68: Amortización",null,null,null,null,"Variable","Fijo"]
[null,null,null,null,null,null,null,null,null,null,null,"Coste Adqui.","V. Residual","Vida Útil",{"$f":"O14+O17+O18","v":2505},{"$f":"P14+P17+P18","v":364}]
[null,"N_62: Servicios Exteriores",null,null,null,null,"Variable","Fijo",null,"Inmovilizado Intangible:"]
[null,"(621) Arrend. y Canónes, alquiler  de garaje",null,null,null,{"$f":"'Costes Estimados'!D13","v":720},null,{"$f":"F14","v":720},null,"Licencia",null,50000,null,null,null,0]
[null,"(622.1) Servicio de mecánica rápida",null,null,null,{"$f":"SUM(H15:H15)","v":80},445,{"$f":"F23","v":80},null,"Inmovilizado Material:"]
[null,"Cambio de Aceite:",null,null,null,{"$f":"('Costes Estimados'!F2/15000)*5*8","v":266.66666666666669},null,null,null,"Vehículo",null,{"$f":"13175+850","v":14025},1500,500000,{"$f":"(L16-M16)/N16","v":2.5049999999999999E-2}]
[null,"Refrigerante",null,null,null,{"$f":"('Costes Estimados'!F2/40000)*5*6","v":75},null,null,null,{"$f":"J2","v":"Para la actividad prevista como normal"},null,null,{"$f":"M2","v":100000},null,{"$f":"O16*M17","v":2505}]
[null,"Del sistema de frenado",null,null,null,{"$f":"('Costes Estimados'!F2/40000)*2*10","v":50},null,null,null,"Taxímetro, emisora, GPS…",null,{"$f":"590+200+580+275+175","v":1820},0,5,null,{"$f":"(L18-M18)/N18","v":364}]
[null,"Neumáticos",null,null,null,240]
[null,"Filtros - escobillas",null,null,null,120,null,null,null,"Véase:",{"$f":"HYPERLINK(Hipervinculos!C5,Hipervinculos!E5)","v":"Anexo Amortizaciones (68)"}]
[null,"Amortiguadores",null,null,null,90]
[null,"Bomba del agua",null,null,null,50,null,null,null,"N_69: Otras dotaciones",null,null,null,null,"Variable","Fijo"]
[null,"Pre-itv",null,null,null,80,null,null,null,"(699.9) Otras dotaciones",null,null,null,null,{"$f":"SUM(O24:O26)","v":80},{"$f":"SUM(P25:P26)","v":350}]
[null,"(622.2) Servicio electricidad y electrónica",null,null,null,{"$f":"H24+G24","v":430},{"$f":"SUM(F25:F26)","v":430},null,null,"Reparaciones extraordinarias plurianuales",null,null,null,80,{"$f":"N24","v":80}]
[null,"Averías corrientes, estimación promedio",null,null,null,350,null,null,null,"Chapa - Pintura",null,null,null,300,null,{"$f":"N25","v":300}]
[null,"Sustitución de batería",null,null,null,80,null,null,null,"Rotulaciones y distintivos del taxi",null,null,null,50,null,{"$f":"N26","v":50}]
[null,"(62.X) Otros servicios exteriores",null,null,null,null,{"$f":"'Costes Estimados'!F16+'Costes Estimados'!F17+'Costes Estimados'!F18+'Costes Estimados'!F19","v":0},{"$f":"'Costes Estimados'!G16+'Costes Estimados'!G17+'Costes Estimados'!G18+'Costes Estimados'!G19","v":2602}]
[null,"Estimacion de otros servicios como asesoria fiscal-laboral, seguro vehículo, otras comunicaciones",null,null,null,null,null,null,null,"Véase:",{"$f":"HYPERLINK(Hipervinculos!C9,Hipervinculos!E9)","v":"Anexo Deterioro y otras dotaciones (69)"}]
[]
[null,null,null,null,null,null,null,null,null,"N_XX: Otros costes. Oportunidad, financieros, Bº deseado..",null,null,null,null,"Variable","Fijo"]
[null,"Véase:",{"$f":"HYPERLINK(Hipervinculos!C14,Hipervinculos!E14)","v":"Anexo Servicios Exteriores (62)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O32:O34)","v":0},{"$f":"SUM(P32:P34)","v":18500}]
[null,null,null,null,null,null,null,null,null,"Costes financieros anuales considerados",null,null,"SI",2500,0,{"$f":"IF(M32=\"SI\",N32,0)","v":2500}]
["N_63: Impuestos",null,null,null,null,null,null,null,null,"Coste de oportunidad del año",null,null,"SI",1000,0,{"$f":"IF(M33=\"SI\",N33,0)","v":1000}]
["Se recogen los impuestos diversos relacionados con el ejercicio de la actividad",null,null,null,null,null,null,null,null,"Beneficio deseado",null,null,"SI",15000,0,{"$f":"IF(M34=\"SI\",N34,0)","v":15000}]
[]
[null,null,null,null,null,null,null,null,null,"Véase:",{"$f":"HYPERLINK(Hipervinculos!C12,Hipervinculos!E12)","v":"Anexo Otros costes (XX)"}]
[null,"Véase:",{"$f":"HYPERLINK(Hipervinculos!C10,Hipervinculos!E10)","v":"Anexo Impuestos (63)"}]

{"sheet":"KPIs","index":6,"n_rows":11,"n_cols":29,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,28,6,28],[7,28,8,28],[3,26,4,26],[3,28,4,28],[5,20,6,20],[7,20,8,20],[7,22,8,22],[5,22,6,22],[5,24,6,24],[7,24,8,24],[5,26,6,26],[7,26,8,26],[3,22,4,22],[3,24,4,24],[5,15,6,15],[7,15,8,15],[2,19,2,21],[5,17,6,17],[7,17,8,17],[5,19,6,19],[3,20,4,20],[7,9,8,9],[5,11,6,11],[3,13,4,13],[5,13,6,13],[7,11,8,11],[7,13,8,13],[9,6,10,6],[3,9,4,9],[7,19,8,19],[9,19,10,19],[7,1,8,1],[3,4,4,4],[3,2,4,2],[5,6,6,6],[3,7,4,7],[7,6,8,6],[3,11,4,11],[3,15,4,15],[3,17,4,17],[5,7,6,7],[7,7,8,7],[5,9,6,9]]}
[]
[]
[null,"Análisis de la Subactividad",null,null,null,null,"Márgenes y Resultados",null,null,null,null,null,null,null,null,null,null,null,null,"KPI's del sector"]
[null,null,"Kilómetros año",null,"Carreras año",null,null,"Ingresos Estimados",null,"Costes Directos (C.V)",null,"Costes Fijos Imputables",null,"Costes Subactividad",null,"Rtd. Analítico Total",null,"Rtd. Analítico Ajustado",null,null,"Ingreso por Km recorrido",null,"Rtd. Bruto por Km",null,"Rtd. Bruto por Carrera",null,"Rtd. Ajustado por Km",null,"Rtd. Ajustado por Carrera"]
[]
[null,"Normal",{"$f":"'Rtdo Analitico y KPI'!D4","v":100000},null,{"$f":"'Rtdo Analitico y KPI'!D6","v":30000},null,"Normal",{"$f":"'Rtdo Analitico y KPI'!D11","v":135800},null,{"$f":"'Rtdo Analitico y KPI'!D13","v":9184},null,{"$f":"'Rtdo Analitico y KPI'!D26","v":60858.899999999994},null,{"$f":"INT('Rtdo Analitico y KPI'!D24)","v":3203},null,{"$f":"'Rtdo Analitico y KPI'!D29","v":62554},null,{"$f":"'Rtdo Analitico y KPI'!D33","v":18500},null,"Normal",{"$f":"'Rtdo Analitico y KPI'!D11/'Rtdo Analitico y KPI'!D4","v":1.3580000000000001},null,{"$f":"'Rtdo Analitico y KPI'!D30","v":0.62553999999999998},null,{"$f":"'Rtdo Analitico y KPI'!D31","v":2.0851333333333333},null,{"$f":"'Rtdo Analitico y KPI'!D35","v":0.44053999999999999},null,{"$f":"'Rtdo Analitico y KPI'!D36","v":1.4684666666666666}]
[null,"Simulación",{"$f":"'Rtdo Analitico y KPI'!F4","v":95000},null,{"$f":"'Rtdo Analitico y KPI'!F6","v":27000}]
[null,"Tasa y Coste de Subactividad",{"$f":"'Rtdo Analitico y KPI'!D5","v":-5.0000000000000044E-2},null,{"$f":"'Rtdo Analitico y KPI'!D7","v":-9.9999999999999978E-2},null,"Simulación",{"$f":"'Rtdo Analitico y KPI'!F11","v":127950},null,{"$f":"'Rtdo Analitico y KPI'!F13","v":9184},null,{"$f":"'Rtdo Analitico y KPI'!F26","v":60858.899999999994},null,{"$f":"INT('Rtdo Analitico y KPI'!F24)","v":3203},null,{"$f":"'Rtdo Analitico y KPI'!F29","v":54704},null,{"$f":"'Rtdo Analitico y KPI'!F33","v":18500},null,"Simulación",{"$f":"'Rtdo Analitico y KPI'!F11/'Rtdo Analitico y KPI'!F4","v":1.3468421052631578},null,{"$f":"'Rtdo Analitico y KPI'!F30","v":0.57583157894736847},null,{"$f":"'Rtdo Analitico y KPI'!F31","v":2.0260740740740739},null,{"$f":"'Rtdo Analitico y KPI'!F35","v":0.38109473684210526},null,{"$f":"'Rtdo Analitico y KPI'!F36","v":1.3408888888888888}]
[null,null,{"$f":"'Rtdo Analitico y KPI'!F24","v":3203.1000000000026},null,{"$f":"'Rtdo Analitico y KPI'!F25","v":6406.1999999999989}]
[null,null,null,null,null,null,"Variación",{"$f":"H8-H6","v":-7850},null,{"$f":"J8-J6","v":0},null,{"$f":"L8-L6","v":0},null,{"$f":"N8-N6","v":0},null,{"$f":"P8-P6","v":-7850},null,{"$f":"R8-R6","v":0},null,"Variación",{"$f":"U8-U6","v":-1.1157894736842255E-2},null,{"$f":"W8-W6","v":-4.9708421052631513E-2},{"$f":"X8-X6","v":0},-5.9059259259259367E-2,null,{"$f":"AA8-AA6","v":-5.9445263157894723E-2},null,-0.12757777777777779]
[null,null,null,null,null,null,null,{"$f":"H10/H6","v":-5.7805596465390283E-2},null,{"$f":"J10/J6","v":0},null,{"$f":"L10/L6","v":0},null,{"$f":"N10/N6","v":0},null,{"$f":"P10/P6","v":-0.12549157527895899},null,{"$f":"R10/R6","v":0},null,null,{"$f":"U10/U6","v":-8.2164173319898785E-3},null,{"$f":"W10/W6","v":-7.9464816083114606E-2},{"$f":"X10/X6","v":{"$error":"#DIV/0!"}},-2.8323972532176694E-2,null,-0.13493726598695857,null,-8.6878225208456297E-2]

{"sheet":"Hipervinculos","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Hipervinculo al documento Word llamado:",null,null,"Anexo.docx"]
["No convertir en tabla para evitar ordenar"]
["Ruta","Marcador de Word","Hipervinculo","Nombre 1","Nombre 2"]
["Anexo.docx","Actividad",{"$f":"A4&\"#\"&B4","v":"Anexo.docx#Actividad"},"N2"]
["Anexo.docx","Amortizaciones","Anexo.docx#Amortizaciones",null,"Anexo Amortizaciones (68)"]
["Anexo.docx","Aspectos_legales","Anexo.docx#Aspectos_legales"]
["Anexo.docx","Capacidad","Anexo.docx#Capacidad","N1"]
["Anexo.docx","Consumos","Anexo.docx#Consumos","N4","Anexo Consumo (60.61)"]
["Anexo.docx","Deterioro","Anexo.docx#Deterioro",null,"Anexo Deterioro y otras dotaciones (69)"]
["Anexo.docx","Impuestos","Anexo.docx#Impuestos",null,"Anexo Impuestos (63)"]
["Anexo.docx","Ingresos","Anexo.docx#Ingresos","N3","Anexo Ingresos (70..)"]
["Anexo.docx","Oportunidad","Anexo.docx#Oportunidad","N5","Anexo Otros costes (XX)"]
["Anexo.docx","Personal","Anexo.docx#Personal",null,"Anexo Pesonal (64)"]
["Anexo.docx","Servicios","Anexo.docx#Servicios",null,"Anexo Servicios Exteriores (62)"]